<?php include_once('Connections/tfccom_db.php'); ?>
<?php
mysql_select_db($database_tfccom_db, $tfccom_db);

$query_feature = "SELECT apartment.id, image, name, neighborhood, num_bedrooms, ROUND(num_bathrooms) AS num_bathrooms, price, apt_type, building_id
FROM apartment, featured_units, building, neighborhood
WHERE apartment.building_id = building.id AND building.neighborhood_id = neighborhood.id AND apartment.id = featured_units.apt_id AND apt_type = 'rental' ORDER BY price ASC";
$feature = mysql_query($query_feature, $tfccom_db) or die(mysql_error());
$row_feature = mysql_fetch_assoc($feature);
?>
<!DOCTYPE html>

<!--[if lt IE 7]>       <html class="ie6">  <![endif]-->
<!--[if IE 7]>          <html class="ie7">  <![endif]-->
<!--[if IE 8]>          <html class="ie8">  <![endif]-->
<!--[if gt IE 8]><!-->  <html lang='en-US'> <!--<![endif]-->

<head>
<meta charset='UTF-8' />
<meta name="viewport" content="width=640" />
<meta name="format-detection" content="telephone=no" />
<link rel="apple-touch-icon" href="iphone_icon.png" />
<link rel='shortcut icon' href='favicon.ico'>
<link rel='stylesheet' href='css/style.css'>
<title></title>
<script type="text/javascript">

var _gaq = _gaq || [];
_gaq.push(['_setAccount', 'UA-9374994-1']);
_gaq.push(['_setDomainName', 'tfcornerstone.com']);
_gaq.push(['_trackPageview']);

(function() {
 var ga = document.createElement('script'); ga.type = 'text/javascript'; ga.async = true;
 ga.src = ('https:' == document.location.protocol ? 'https://ssl' : 'http://www') + '.google-analytics.com/ga.js';
 var s = document.getElementsByTagName('script')[0]; s.parentNode.insertBefore(ga, s);
 })();

</script>
</head>

<body class='about'>

<!-- ****** HEADER ****** -->
<div id='header'>
<a href="home.php"><div class='logo'><p>TF Cornerstone</p></div></a>
<div class='phone-button'><a href='tel:212.672.1000'>Call</a></div>
</div><!-- #header -->


<!-- ****** SLIDER ****** -->
<div id='slide'>
<img src='images/slide.jpg' alt='Search for your new home'/>
</div><!-- #slide -->


<!-- ****** CONTENT ****** -->
<div id='content'>
<div id='map-this'>
<p><br>
387 Park Ave South, <br>
New York, NY 10016</p>
<br><a href='http://maps.google.com/maps?q=387 Park AVe South,&nbsp;New York, NY 10016' class='map-this button'>Map this</a>
</div><!-- #map-this -->
<div class='text'>
<h2>About</h2>
<p>TF Cornerstone is a partnership of two brothers, Tom and Fred Elghanayan, focused on acquisition, development, construction and management of fine residential, commercial and retail properties. In addition to an aggressive acquisition strategy, reliable construction division, the company holds a solid, fully-operational portfolio of luxury residential buildings, modern office spaces and highly visible retail locations totaling over 8 million square feet throughout New York City and Washington, D.C.</p>
</div>

<h2>Featured listings</h2>
<?php	
	do
	{
?>
    <div class='listing'><a href='unit_page.php?id=<?php echo $row_feature['id']; ?>'><div style=" background:url(http://www.tfcornerstone.com/images/building/<?php echo $row_feature['image'];?>) no-repeat 50% 0; background-position:50% 50%;width:292px; height:210px;overflow:hidden; float:left"></div>
<div class='listing-info'>
	<p class='first-line'><?php echo($row_feature['name']) ?></p><p><?php echo($row_feature['neighborhood']) ?></p><p><?php
		if($row_feature['num_bedrooms']==0)
		{
		  	echo 'Studio';
		}
		else
		{
		   echo($row_feature['num_bedrooms']) ?> BD<?php    }?> / <?php echo($row_feature['num_bathrooms']) ?> BA</p><p>$<?php echo(number_format($row_feature['price'])) ?>&nbsp;<?php echo($row_feature['apt_type']) ?></p>
</div></a>
</div><!-- .listing -->
          
 <?php } while ($row_feature = mysql_fetch_assoc($feature));
 
 ?>
 </div><!-- #content -->


<!-- ****** FOOTER ****** -->
<div id='footer'>

<a href="home.php"><div class='logo'><p>TF Cornerstone</p></div></a>


<div class='contacts'>
<p>387 Park Ave South, New York, NY 10016</p>
<p>MAIN: 212.672.1000 FAX: 212.672.1001</p>
</div>

<a class='full-site-button' href='http://www.tfcornerstone.com?desktop'>FULL SITE</a>

<div style="color:white; margin:20px 0 20px 0;overflow:auto">
          <div style="float:left;border-right:solid white;padding:0 30px 0 30px"><a href="home.php" style="font-size:28px;color:white">HOME</a></div>
          <div style="float:left;border-right:solid white;padding:0 30px 0 30px"><a href="about.php" style="font-size:28px;color:white">ABOUT</a></div>
          <div style="float:left;padding:0 0 0 30px"><a href="http://www.tfc.com/forms/privacy_policy.php?back=false" target="_blank" style="font-size:28px;color:white">DISCLAIMER</a></div>
</div>
<ul class='icons'>
<li class='google-plus'><a href="http://gplus.to/tfcornerstone" target="_blank">Google+</a></li>
<li class='twitter'><a href="http://twitter.com/#!/tfcornerstone" target="_blank">Twitter</a></li>
<li class='facebook'><a href="https://www.facebook.com/TFCrealestate" target="_blank">Facebook</a></li>
<li class='youtube'><a href="http://www.youtube.com/tfcornerstone" target="_blank">Youtube</a></li>
<li class='linked-in'><a href="http://www.linkedin.com/company/tf-cornerstone" target="_blank">Linked In</a></li>
<li class='rss'>
<?php
if(strstr($_SERVER['HTTP_USER_AGENT'],'Android')) { 
?>
	<a href="http://www.tfcornerstone.com/new-york-city-life/" target="_blank">RSS</a>
<?php	
} 
else { 
?>
	<a href="http://www.tfcornerstone.com/new-york-city-life/feed/" target="_blank">RSS</a>
<?php
}
 ?></li>
<li class='helper'></li>
</ul>

<p class='copyright'>&copy; 2012 <span>TF Cornerstone</span> INC</p>
<p class='copyright' style=" font-size:12px">EQUAL HOUSING OPPORTUNITY</p>
</div><!-- #footer -->

</body>

</html>